object frmGoodsInfoMng: TfrmGoodsInfoMng
  Left = 0
  Top = 0
  Caption = 'Goods Info Manage'
  ClientHeight = 538
  ClientWidth = 900
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 13
  object dbgdGoodsInfo: TDBGridEh
    Left = 0
    Top = 41
    Width = 900
    Height = 497
    Align = alClient
    DataGrouping.GroupLevels = <>
    DataSource = dsGoodsInfo
    Flat = False
    FooterColor = clWindow
    FooterFont.Charset = DEFAULT_CHARSET
    FooterFont.Color = clWindowText
    FooterFont.Height = -11
    FooterFont.Name = 'Tahoma'
    FooterFont.Style = []
    FooterRowCount = 1
    IndicatorOptions = [gioShowRowIndicatorEh]
    ReadOnly = True
    SumList.Active = True
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    Columns = <
      item
        EditButtons = <>
        FieldName = 'style'
        Footer.Alignment = taRightJustify
        Footer.Value = 'Record'
        Footer.ValueType = fvtStaticText
        Footers = <>
        Title.Caption = #27454#24335
        Width = 180
      end
      item
        EditButtons = <>
        FieldName = 'barcode'
        Footer.Alignment = taRightJustify
        Footer.FieldName = 'barcode'
        Footer.ValueType = fvtCount
        Footers = <>
        Width = 83
      end
      item
        EditButtons = <>
        FieldName = 'code'
        Footers = <>
        Width = 200
      end
      item
        EditButtons = <>
        FieldName = 'name'
        Footer.Alignment = taRightJustify
        Footers = <>
        Title.Caption = #21517#31216
        Width = 246
      end
      item
        EditButtons = <>
        FieldName = 'size'
        Footers = <>
        Title.Caption = #22823#23567
        Width = 64
      end
      item
        EditButtons = <>
        FieldName = 'brand'
        Footers = <>
        Title.Caption = #21697#29260
        Width = 64
      end
      item
        EditButtons = <>
        FieldName = 'color'
        Footers = <>
        Title.Caption = #39068#33394
      end
      item
        EditButtons = <>
        FieldName = 'gender'
        Footers = <>
        Title.Caption = #24615#21035
      end
      item
        EditButtons = <>
        FieldName = 'grade'
        Footers = <>
        Title.Caption = #31561#32423
      end
      item
        EditButtons = <>
        FieldName = 'producer'
        Footers = <>
        Title.Caption = #20135#22320
        Width = 64
      end
      item
        EditButtons = <>
        FieldName = 'salePrice'
        Footers = <>
        Title.Caption = #38144#21806#20215
      end
      item
        EditButtons = <>
        FieldName = 'standard'
        Footers = <>
        Title.Caption = #26631#20934
        Width = 163
      end
      item
        EditButtons = <>
        FieldName = 'material'
        Footers = <>
        Title.Caption = #25104#20221'1'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'material2'
        Footers = <>
        Title.Caption = #25104#20221'2'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'material3'
        Footers = <>
        Title.Caption = #25104#20221'3'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'material4'
        Footers = <>
        Title.Caption = #25104#20221'4'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'Description'
        Footers = <>
        Title.Caption = #25551#36848
        Width = 373
      end
      item
        EditButtons = <>
        FieldName = 'kind'
        Footers = <>
        Title.Caption = #22823#20998#31867
        Width = 170
      end
      item
        EditButtons = <>
        FieldName = 'item'
        Footers = <>
        Title.Caption = #23567#20998#31867
        Width = 177
      end
      item
        EditButtons = <>
        FieldName = 'Collection'
        Footers = <>
        Title.Caption = #31995#21015
        Width = 210
      end
      item
        EditButtons = <>
        FieldName = 'othercode'
        Footers = <>
        Title.Caption = 'Other Code'
        Width = 267
      end>
    object RowDetailData: TRowDetailPanelControlEh
    end
  end
  object pnlSearch: TPanel
    Left = 0
    Top = 0
    Width = 900
    Height = 41
    Align = alTop
    TabOrder = 0
    DesignSize = (
      900
      41)
    object btnSearch: TButton
      Left = 13
      Top = 10
      Width = 75
      Height = 25
      Caption = #24320#22987#25628#32034
      TabOrder = 0
      OnClick = btnSearchClick
    end
    object btnExport: TButton
      Left = 655
      Top = 10
      Width = 75
      Height = 25
      Anchors = [akTop, akRight]
      Caption = #23548#20986
      TabOrder = 1
      OnClick = btnExportClick
    end
    object btnDetailAdd: TButton
      Left = 736
      Top = 10
      Width = 75
      Height = 25
      Anchors = [akTop, akRight]
      Caption = #26032#22686
      TabOrder = 2
      OnClick = btnDetailAddClick
    end
    object btnDetailEdit: TButton
      Left = 817
      Top = 10
      Width = 75
      Height = 25
      Anchors = [akTop, akRight]
      Caption = #20462#25913
      TabOrder = 3
      OnClick = btnDetailEditClick
    end
    object BtnImport: TButton
      Left = 574
      Top = 10
      Width = 75
      Height = 25
      Anchors = [akTop, akRight]
      Caption = #23548#20837
      TabOrder = 4
      OnClick = BtnImportClick
    end
  end
  object myqryGoodsInfo: TMyQuery
    SQLInsert.Strings = (
      'INSERT INTO goodsinfo'
      
        '  (id, barcode, code, name, brand, style, gender, size, SIZEGD, ' +
        'season, color, grade, producer, material, salePrice, Description' +
        ', standard, material2, material3, material4, kind, item, Collect' +
        'ion, othercode)'
      'VALUES'
      
        '  (:id, :barcode, :code, :name, :brand, :style, :gender, :size, ' +
        ':SIZEGD, :season, :color, :grade, :producer, :material, :salePri' +
        'ce, :Description, :standard, :material2, :material3, :material4,' +
        ' :kind, :item, :Collection, :othercode)')
    SQLDelete.Strings = (
      'DELETE FROM goodsinfo'
      'WHERE'
      '  id = :Old_id')
    SQLUpdate.Strings = (
      'UPDATE goodsinfo'
      'SET'
      
        '  id = :id, barcode = :barcode, code = :code, name = :name, bran' +
        'd = :brand, style = :style, gender = :gender, size = :size, SIZE' +
        'GD = :SIZEGD, season = :season, color = :color, grade = :grade, ' +
        'producer = :producer, material = :material, salePrice = :salePri' +
        'ce, Description = :Description, standard = :standard, material2 ' +
        '= :material2, material3 = :material3, material4 = :material4, ki' +
        'nd = :kind, item = :item, Collection = :Collection, othercode = ' +
        ':othercode'
      'WHERE'
      '  id = :Old_id')
    SQLRefresh.Strings = (
      
        'SELECT id, barcode, code, name, brand, style, gender, size, SIZE' +
        'GD, season, color, grade, producer, material, salePrice, Descrip' +
        'tion, standard, material2, material3, material4, kind, item, Col' +
        'lection, othercode FROM goodsinfo'
      'WHERE'
      '  id = :id')
    SQLLock.Strings = (
      'SELECT * FROM goodsinfo'
      'WHERE'
      '  id = :Old_id'
      'FOR UPDATE')
    Connection = DMMySQL.conMySQL
    SQL.Strings = (
      'select * from goodsinfo order by barcode')
    KeyFields = 'id'
    Left = 144
    Top = 104
  end
  object dsPrdGoodsInfo: TDataSetProvider
    DataSet = myqryGoodsInfo
    UpdateMode = upWhereKeyOnly
    OnUpdateError = dsPrdGoodsInfoUpdateError
    Left = 208
    Top = 104
  end
  object cdsGoodsInfo: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsPrdGoodsInfo'
    Left = 304
    Top = 112
    object cdsGoodsInfoid: TLargeintField
      FieldName = 'id'
    end
    object cdsGoodsInfobarcode: TWideStringField
      FieldName = 'barcode'
    end
    object cdsGoodsInfocode: TWideStringField
      FieldName = 'code'
      Size = 50
    end
    object cdsGoodsInfoname: TWideStringField
      FieldName = 'name'
      Size = 50
    end
    object cdsGoodsInfobrand: TWideStringField
      FieldName = 'brand'
    end
    object cdsGoodsInfostyle: TWideStringField
      FieldName = 'style'
      Size = 30
    end
    object cdsGoodsInfogender: TWideStringField
      FieldName = 'gender'
      Size = 10
    end
    object cdsGoodsInfosize: TWideStringField
      FieldName = 'size'
      Size = 15
    end
    object cdsGoodsInfoSIZEGD: TWideStringField
      FieldName = 'SIZEGD'
      Size = 15
    end
    object cdsGoodsInfoseason: TWideStringField
      FieldName = 'season'
      Size = 4
    end
    object cdsGoodsInfocolor: TWideStringField
      FieldName = 'color'
      Size = 10
    end
    object cdsGoodsInfograde: TWideStringField
      FieldName = 'grade'
      Size = 10
    end
    object cdsGoodsInfoproducer: TWideStringField
      FieldName = 'producer'
      Size = 30
    end
    object cdsGoodsInfomaterial: TWideStringField
      FieldName = 'material'
      Size = 200
    end
    object cdsGoodsInfosalePrice: TFloatField
      FieldName = 'salePrice'
    end
    object cdsGoodsInfoDescription: TWideStringField
      FieldName = 'Description'
      Size = 255
    end
    object cdsGoodsInfostandard: TWideStringField
      FieldName = 'standard'
      Size = 100
    end
    object cdsGoodsInfomaterial2: TWideStringField
      FieldName = 'material2'
      Size = 200
    end
    object cdsGoodsInfomaterial3: TWideStringField
      FieldName = 'material3'
      Size = 200
    end
    object cdsGoodsInfomaterial4: TWideStringField
      FieldName = 'material4'
      Size = 200
    end
    object cdsGoodsInfokind: TWideStringField
      FieldName = 'kind'
      Size = 200
    end
    object cdsGoodsInfoitem: TWideStringField
      FieldName = 'item'
      Size = 200
    end
    object cdsGoodsInfoCollection: TWideStringField
      FieldName = 'Collection'
      Size = 50
    end
    object cdsGoodsInfoothercode: TWideStringField
      FieldName = 'othercode'
      Size = 100
    end
  end
  object dsGoodsInfo: TDataSource
    DataSet = cdsGoodsInfo
    Left = 376
    Top = 112
  end
end
